To Create a Domain on a Table

Use the following primary table:
CREATE TABLE STREET

(OBJECTID NUMBER PRIMARY KEY,

SEGMENTID NUMBER,

STREETID NUMBER,

MAPID NUMBER,

NAME VARCHAR2(50),

STREET_TYP VARCHAR2(50),

SHAPE_Leng NUMBER,

GEOMETRY MDSYS.SDO_GEOMETRY);
Create the domain table.
CREATE TABLE DOMAIN_STREET_TYPE

("TYPE" VARCHAR2(10) NOT NULL,

"DESCRIPTION" VARCHAR2(64),

CONSTRAINT "DOMAIN_STREET_TYPE_PK" PRIMARY KEY("TYPE"));

Insert into DOMAIN_STREET_TYPE("TYPE", "DESCRIPTION") values ('Highway','Highway');

Insert into DOMAIN_STREET_TYPE("TYPE", "DESCRIPTION") values ('Primary','Primary Road');

Insert into DOMAIN_STREET_TYPE("TYPE", "DESCRIPTION") values ('Secondary','Secondary Road');

Insert into DOMAIN_STREET_TYPE("TYPE", "DESCRIPTION") values ('Unpaved','Unpaved Road');
Create a foreign key constraint.
alter table street

add constraint DOMAIN_STREET_TYPE_FK

foreign key(STREET_TYP)

references DOMAIN_STREET_TYPE(TYPE)

disable;